Pandas Profiling Report

Dataset statistics

Number of variables	10
Number of observations	514
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	40.3 KiB
Average record size in memory	80.2 B

Variable types

Numeric	8
Categorical	2

Warnings

`link` has a high cardinality: 461 distinct values	High cardinality
`name` has a high cardinality: 459 distinct values	High cardinality
`age` is highly correlated with `amount_bricks` and 1 other fields	High correlation
`amount_bricks` is highly correlated with `age` and 1 other fields	High correlation
`price` is highly correlated with `age` and 1 other fields	High correlation
`rating_amount` is highly correlated with `rating_worth` and 1 other fields	High correlation
`rating_worth` is highly correlated with `rating_amount` and 1 other fields	High correlation
`rating_fun` is highly correlated with `rating_amount` and 1 other fields	High correlation
`age` is highly correlated with `amount_bricks` and 1 other fields	High correlation
`amount_bricks` is highly correlated with `age` and 1 other fields	High correlation
`price` is highly correlated with `age` and 1 other fields	High correlation
`rating_amount` is highly correlated with `rating_worth` and 1 other fields	High correlation
`rating_worth` is highly correlated with `rating_amount` and 1 other fields	High correlation
`rating_fun` is highly correlated with `rating_amount` and 1 other fields	High correlation
`Unnamed: 0` is highly correlated with `rating_amount` and 2 other fields	High correlation
`age` is highly correlated with `rating_amount` and 2 other fields	High correlation
`amount_bricks` is highly correlated with `price` and 3 other fields	High correlation
`price` is highly correlated with `amount_bricks` and 3 other fields	High correlation
`rating_amount` is highly correlated with `Unnamed: 0` and 5 other fields	High correlation
`rating_worth` is highly correlated with `Unnamed: 0` and 5 other fields	High correlation
`rating_fun` is highly correlated with `Unnamed: 0` and 5 other fields	High correlation
`amount_bricks` is highly correlated with `price` and 1 other fields	High correlation
`price` is highly correlated with `amount_bricks` and 3 other fields	High correlation
`rating_amount` is highly correlated with `price` and 2 other fields	High correlation
`Unnamed: 0` is highly correlated with `age`	High correlation
`product_number` is highly correlated with `price`	High correlation
`rating_fun` is highly correlated with `price` and 2 other fields	High correlation
`age` is highly correlated with `amount_bricks` and 1 other fields	High correlation
`rating_worth` is highly correlated with `rating_amount` and 1 other fields	High correlation
`Unnamed: 0` is uniformly distributed	Uniform
`link` is uniformly distributed	Uniform
`name` is uniformly distributed	Uniform
`Unnamed: 0` has unique values	Unique
`product_number` has 21 (4.1%) zeros	Zeros
`price` has 21 (4.1%) zeros	Zeros
`rating_amount` has 450 (87.5%) zeros	Zeros
`rating_worth` has 450 (87.5%) zeros	Zeros
`rating_fun` has 450 (87.5%) zeros	Zeros

Reproduction

Analysis started	2021-09-20 14:16:25.148566
Analysis finished	2021-09-20 14:17:37.528694
Duration	1 minute and 12.38 seconds
Software version	pandas-profiling v3.0.0
Download configuration	config.json

Unnamed: 0
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
UNIFORM
UNIQUE

Distinct	514
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	256.5

Minimum	0
Maximum	513
Zeros	1
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	4.1 KiB

Quantile statistics

Minimum	0
5-th percentile	25.65
Q1	128.25
median	256.5
Q3	384.75
95-th percentile	487.35
Maximum	513
Range	513
Interquartile range (IQR)	256.5

Descriptive statistics

Standard deviation	148.5232866
Coefficient of variation (CV)	0.5790381544
Kurtosis	-1.2
Mean	256.5
Median Absolute Deviation (MAD)	128.5
Skewness	0
Sum	131841
Variance	22059.16667
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	0.2%
385	1	0.2%
351	1	0.2%
350	1	0.2%
349	1	0.2%
348	1	0.2%
347	1	0.2%
346	1	0.2%
345	1	0.2%
344	1	0.2%
Other values (504)	504	98.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	0.2%
1	1	0.2%
2	1	0.2%
3	1	0.2%
4	1	0.2%
5	1	0.2%
6	1	0.2%
7	1	0.2%
8	1	0.2%
9	1	0.2%

Value	Count	Frequency (%)
513	1	0.2%
512	1	0.2%
511	1	0.2%
510	1	0.2%
509	1	0.2%
508	1	0.2%
507	1	0.2%
506	1	0.2%
505	1	0.2%
504	1	0.2%

link
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	461
Distinct (%)	89.7%
Missing	0
Missing (%)	0.0%
Memory size	4.1 KiB

https://www.lego.com/da-dk/product/batman-40386	3
https://www.lego.com/da-dk/product/the-joker-40428	3
https://www.lego.com/da-dk/product/app-controlled-top-gear-rally-car-42109	2
https://www.lego.com/da-dk/product/first-order-stormtrooper-40391	2
https://www.lego.com/da-dk/product/voldemort-nagini-bellatrix-40496	2
Other values (456)	502

Length

Max length	105
Median length	61
Mean length	61.92412451
Min length	44

Characters and Unicode

Total characters	31.829
Distinct characters	41
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	410 ?
Unique (%)	79.8%

Sample

1st row	https://www.lego.com/da-dk/product/empire-state-building-21046
2nd row	https://www.lego.com/da-dk/product/statue-of-liberty-21042
3rd row	https://www.lego.com/da-dk/product/taj-mahal-21056
4th row	https://www.lego.com/da-dk/product/trafalgar-square-21045
5th row	https://www.lego.com/da-dk/product/the-white-house-21054

Common Values

Value	Count	Frequency (%)
https://www.lego.com/da-dk/product/batman-40386	3	0.6%
https://www.lego.com/da-dk/product/the-joker-40428	3	0.6%
https://www.lego.com/da-dk/product/app-controlled-top-gear-rally-car-42109	2	0.4%
https://www.lego.com/da-dk/product/first-order-stormtrooper-40391	2	0.4%
https://www.lego.com/da-dk/product/voldemort-nagini-bellatrix-40496	2	0.4%
https://www.lego.com/da-dk/product/belle-bottom-kevin-and-bob-40421	2	0.4%
https://www.lego.com/da-dk/product/disney-s-mickey-mouse-31202	2	0.4%
https://www.lego.com/da-dk/product/the-ice-castle-43197	2	0.4%
https://www.lego.com/da-dk/product/bruni-the-salamander-buildable-character-43186	2	0.4%
https://www.lego.com/da-dk/product/4x4-x-treme-off-roader-42099	2	0.4%
Other values (451)	492	95.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
https://www.lego.com/da-dk/product/batman-40386	3	0.6%
https://www.lego.com/da-dk/product/the-joker-40428	3	0.6%
https://www.lego.com/da-dk/product/app-controlled-top-gear-rally-car-42109	2	0.4%
https://www.lego.com/da-dk/product/first-order-stormtrooper-40391	2	0.4%
https://www.lego.com/da-dk/product/voldemort-nagini-bellatrix-40496	2	0.4%
https://www.lego.com/da-dk/product/belle-bottom-kevin-and-bob-40421	2	0.4%
https://www.lego.com/da-dk/product/disney-s-mickey-mouse-31202	2	0.4%
https://www.lego.com/da-dk/product/the-ice-castle-43197	2	0.4%
https://www.lego.com/da-dk/product/bruni-the-salamander-buildable-character-43186	2	0.4%
https://www.lego.com/da-dk/product/4x4-x-treme-off-roader-42099	2	0.4%
Other values (451)	492	95.7%

Most occurring characters

Value	Count	Frequency (%)
/	2570	8.1%
-	2286	7.2%
t	2249	7.1%
o	2218	7.0%
d	1856	5.8%
w	1643	5.2%
e	1596	5.0%
c	1422	4.5%
a	1397	4.4%
r	1306	4.1%
Other values (31)	13286	41.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	22730	71.4%
Other Punctuation	4112	12.9%
Decimal Number	2699	8.5%
Dash Punctuation	2286	7.2%
Other Letter	2	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	2249	9.9%
o	2218	9.8%
d	1856	8.2%
w	1643	7.2%
e	1596	7.0%
c	1422	6.3%
a	1397	6.1%
r	1306	5.7%
p	1259	5.5%
s	1122	4.9%
Other values (16)	6662	29.3%

Decimal Number

Value	Count	Frequency (%)
1	507	18.8%
0	377	14.0%
4	317	11.7%
7	277	10.3%
2	248	9.2%
3	218	8.1%
9	200	7.4%
6	197	7.3%
5	192	7.1%
8	166	6.2%

Other Punctuation

Value	Count	Frequency (%)
/	2570	62.5%
.	1028	25.0%
:	514	12.5%

Dash Punctuation

Value	Count	Frequency (%)
-	2286	100.0%

Other Letter

Value	Count	Frequency (%)
ǀ	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	22732	71.4%
Common	9097	28.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	2249	9.9%
o	2218	9.8%
d	1856	8.2%
w	1643	7.2%
e	1596	7.0%
c	1422	6.3%
a	1397	6.1%
r	1306	5.7%
p	1259	5.5%
s	1122	4.9%
Other values (17)	6664	29.3%

Common

Value	Count	Frequency (%)
/	2570	28.3%
-	2286	25.1%
.	1028	11.3%
:	514	5.7%
1	507	5.6%
0	377	4.1%
4	317	3.5%
7	277	3.0%
2	248	2.7%
3	218	2.4%
Other values (4)	755	8.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	31827	> 99.9%
Latin Ext B	2	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
/	2570	8.1%
-	2286	7.2%
t	2249	7.1%
o	2218	7.0%
d	1856	5.8%
w	1643	5.2%
e	1596	5.0%
c	1422	4.5%
a	1397	4.4%
r	1306	4.1%
Other values (30)	13284	41.7%

Latin Ext B

Value	Count	Frequency (%)
ǀ	2	100.0%

name
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	459
Distinct (%)	89.3%
Missing	0
Missing (%)	0.0%
Memory size	4.1 KiB

Batman™	3
Jokeren	3
Firhjulstrukket X-trem offroader	2
Daily Bugle	2
Joakim von And, Rip, Rap og Rup	2
Other values (454)	502

Length

Max length	67
Median length	20
Mean length	21.07003891
Min length	3

Characters and Unicode

Total characters	10.830
Distinct characters	87
Distinct categories	11 ?
Distinct scripts	2 ?
Distinct blocks	5 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	406 ?
Unique (%)	79.0%

Sample

1st row	Empire State Building
2nd row	Frihedsgudinden
3rd row	Taj Mahal
4th row	Trafalgar Square
5th row	Det Hvide Hus

Common Values

Value	Count	Frequency (%)
Batman™	3	0.6%
Jokeren	3	0.6%
Firhjulstrukket X-trem offroader	2	0.4%
Daily Bugle	2	0.4%
Joakim von And, Rip, Rap og Rup	2	0.4%
Voldemort™, Nagini og Bellatrix	2	0.4%
Belle Bottom, Kevin og Bob	2	0.4%
Gru, Stuart og Otto	2	0.4%
Frost – isslot	2	0.4%
Arendal slotsby	2	0.4%
Other values (449)	492	95.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
og	52	3.8%
–	33	2.4%
lego®	28	2.0%
med	17	1.2%
batman™	13	0.9%
mod	13	0.9%
klodser	11	0.8%
mouse	9	0.7%
mickey	9	0.7%
i	9	0.7%
Other values (798)	1175	85.8%

Most occurring characters

Value	Count	Frequency (%)
e	1026	9.5%
	850	7.8%
r	755	7.0%
a	645	6.0%
s	601	5.5%
n	587	5.4%
o	575	5.3%
t	571	5.3%
i	513	4.7%
l	418	3.9%
Other values (77)	4289	39.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	8282	76.5%
Uppercase Letter	1261	11.6%
Space Separator	855	7.9%
Dash Punctuation	180	1.7%
Other Symbol	109	1.0%
Decimal Number	85	0.8%
Other Punctuation	51	0.5%
Format	3	< 0.1%
Other Letter	2	< 0.1%
Initial Punctuation	1	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1026	12.4%
r	755	9.1%
a	645	7.8%
s	601	7.3%
n	587	7.1%
o	575	6.9%
t	571	6.9%
i	513	6.2%
l	418	5.0%
d	387	4.7%
Other values (21)	2204	26.6%

Uppercase Letter

Value	Count	Frequency (%)
M	126	10.0%
B	120	9.5%
S	96	7.6%
E	92	7.3%
A	71	5.6%
G	65	5.2%
H	61	4.8%
K	60	4.8%
P	59	4.7%
L	59	4.7%
Other values (17)	452	35.8%

Decimal Number

Value	Count	Frequency (%)
1	19	22.4%
9	16	18.8%
8	14	16.5%
2	11	12.9%
3	10	11.8%
0	8	9.4%
5	3	3.5%
7	2	2.4%
6	1	1.2%
4	1	1.2%

Other Punctuation

Value	Count	Frequency (%)
,	21	41.2%
:	14	27.5%
.	6	11.8%
/	3	5.9%
'	2	3.9%
"	2	3.9%
!	1	2.0%
&	1	2.0%
#	1	2.0%

Space Separator

Value	Count	Frequency (%)
	850	99.4%
	5	0.6%

Other Symbol

Value	Count	Frequency (%)
™	73	67.0%
®	36	33.0%

Dash Punctuation

Value	Count	Frequency (%)
-	147	81.7%
–	33	18.3%

Format

Value	Count	Frequency (%)
	3	100.0%

Other Letter

Value	Count	Frequency (%)
ǀ	2	100.0%

Initial Punctuation

Value	Count	Frequency (%)
“	1	100.0%

Final Punctuation

Value	Count	Frequency (%)
”	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	9545	88.1%
Common	1285	11.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1026	10.7%
r	755	7.9%
a	645	6.8%
s	601	6.3%
n	587	6.1%
o	575	6.0%
t	571	6.0%
i	513	5.4%
l	418	4.4%
d	387	4.1%
Other values (49)	3467	36.3%

Common

Value	Count	Frequency (%)
	850	66.1%
-	147	11.4%
™	73	5.7%
®	36	2.8%
–	33	2.6%
,	21	1.6%
1	19	1.5%
9	16	1.2%
8	14	1.1%
:	14	1.1%
Other values (18)	62	4.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10526	97.2%
Latin 1 Sup	191	1.8%
Letterlike Symbols	73	0.7%
Punctuation	38	0.4%
Latin Ext B	2	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	1026	9.7%
	850	8.1%
r	755	7.2%
a	645	6.1%
s	601	5.7%
n	587	5.6%
o	575	5.5%
t	571	5.4%
i	513	4.9%
l	418	4.0%
Other values (63)	3985	37.9%

Letterlike Symbols

Value	Count	Frequency (%)
™	73	100.0%

Punctuation

Value	Count	Frequency (%)
–	33	86.8%
	3	7.9%
“	1	2.6%
”	1	2.6%

Latin 1 Sup

Value	Count	Frequency (%)
æ	55	28.8%
ø	48	25.1%
å	40	20.9%
®	36	18.8%
	5	2.6%
Æ	4	2.1%
á	2	1.0%
é	1	0.5%

Latin Ext B

Value	Count	Frequency (%)
ǀ	2	100.0%

age
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	15
Distinct (%)	2.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.642023346

Minimum	1
Maximum	18
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.1 KiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	6
median	8
Q3	10
95-th percentile	18
Maximum	18
Range	17
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	4.429682861
Coefficient of variation (CV)	0.5125747389
Kurtosis	0.09835324228
Mean	8.642023346
Median Absolute Deviation (MAD)	2
Skewness	0.9736949455
Sum	4442
Variance	19.62209025
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=15)

Value	Count	Frequency (%)
6	94	18.3%
8	89	17.3%
7	65	12.6%
18	58	11.3%
10	45	8.8%
4	38	7.4%
9	28	5.4%
16	25	4.9%
5	25	4.9%
2	21	4.1%
Other values (5)	26	5.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	4	0.8%
2	21	4.1%
3	3	0.6%
4	38	7.4%
5	25	4.9%
6	94	18.3%
7	65	12.6%
8	89	17.3%
9	28	5.4%
10	45	8.8%

Value	Count	Frequency (%)
18	58	11.3%
16	25	4.9%
14	5	1.0%
12	9	1.8%
11	5	1.0%
10	45	8.8%
9	28	5.4%
8	89	17.3%
7	65	12.6%
6	94	18.3%

amount_bricks
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	366
Distinct (%)	71.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	833.9338521

Minimum	1
Maximum	11695
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.1 KiB

Quantile statistics

Minimum	1
5-th percentile	10.65
Q1	118.25
median	386.5
Q3	973.25
95-th percentile	3318.25
Maximum	11695
Range	11694
Interquartile range (IQR)	855

Descriptive statistics

Standard deviation	1246.781419
Coefficient of variation (CV)	1.495060328
Kurtosis	17.6695095
Mean	833.9338521
Median Absolute Deviation (MAD)	304.5
Skewness	3.416114376
Sum	428642
Variance	1554463.906
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	18	3.5%
50	10	1.9%
90	6	1.2%
33	5	1.0%
34	5	1.0%
36	4	0.8%
234	4	0.8%
73	4	0.8%
565	4	0.8%
466	4	0.8%
Other values (356)	450	87.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	18	3.5%
7	2	0.4%
8	3	0.6%
10	3	0.6%
11	2	0.4%
13	1	0.2%
17	1	0.2%
18	1	0.2%
23	2	0.4%
24	2	0.4%

Value	Count	Frequency (%)
11695	1	0.2%
9036	1	0.2%
7541	1	0.2%
6020	1	0.2%
5685	1	0.2%
5544	1	0.2%
5509	1	0.2%
5100	1	0.2%
4784	1	0.2%
4249	2	0.4%

product_number
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	444
Distinct (%)	86.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.560528431 × 10¹⁸

Minimum	0
Maximum	2.0004312 × 10²⁰
Zeros	21
Zeros (%)	4.1%
Negative	0
Negative (%)	0.0%
Memory size	4.1 KiB

Quantile statistics

Minimum	0
5-th percentile	1.027140271 × 10¹⁴
Q1	3.1100061 × 10¹⁴
median	4.209792098 × 10¹⁴
Q3	7.531150312 × 10¹⁴
95-th percentile	8.001615016 × 10¹⁴
Maximum	2.0004312 × 10²⁰
Range	2.0004312 × 10²⁰
Interquartile range (IQR)	4.421144211 × 10¹⁴

Descriptive statistics

Standard deviation	1.759502963 × 10¹⁹
Coefficient of variation (CV)	11.27504586
Kurtosis	124.7271812
Mean	1.560528431 × 10¹⁸
Median Absolute Deviation (MAD)	2.893228932 × 10¹⁴
Skewness	11.23568835
Sum	8.021116137 × 10²⁰
Variance	3.095850678 × 10³⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	21	4.1%
4.038640386 × 10¹⁴	3	0.6%
4.042840428 × 10¹⁴	3	0.6%
4.04204042 × 10¹⁴	2	0.4%
4.037740377 × 10¹⁴	2	0.4%
4.049640496 × 10¹⁴	2	0.4%
4.042140421 × 10¹⁴	2	0.4%
4.317243172 × 10¹⁴	2	0.4%
2.132621326 × 10¹⁴	2	0.4%
4.2100421 × 10¹⁴	2	0.4%
Other values (434)	473	92.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	21	4.1%
1.025510255 × 10¹⁴	1	0.2%
1.026110261 × 10¹⁴	1	0.2%
1.026410264 × 10¹⁴	1	0.2%
1.026510265 × 10¹⁴	1	0.2%
1.02701027 × 10¹⁴	1	0.2%
1.027210272 × 10¹⁴	1	0.2%
1.027310273 × 10¹⁴	2	0.4%
1.027410274 × 10¹⁴	1	0.2%
1.027610276 × 10¹⁴	1	0.2%

Value	Count	Frequency (%)
2.0004312 × 10²⁰	1	0.2%
2.0004302 × 10²⁰	1	0.2%
2.0004142 × 10²⁰	1	0.2%
2.0004092 × 10²⁰	1	0.2%
8.540658541 × 10¹⁷	1	0.2%
8.538658539 × 10¹⁷	1	0.2%
9.217792178 × 10¹⁴	1	0.2%
9.217692177 × 10¹⁴	1	0.2%
8.801588016 × 10¹⁴	1	0.2%
8.801488015 × 10¹⁴	1	0.2%

price
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	80
Distinct (%)	15.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	656.151751

Minimum	0
Maximum	6999
Zeros	21
Zeros (%)	4.1%
Negative	0
Negative (%)	0.0%
Memory size	4.1 KiB

Quantile statistics

Minimum	0
5-th percentile	30
Q1	180
median	354
Q3	899
95-th percentile	2134
Maximum	6999
Range	6999
Interquartile range (IQR)	719

Descriptive statistics

Standard deviation	790.5202203
Coefficient of variation (CV)	1.204782612
Kurtosis	12.84975148
Mean	656.151751
Median Absolute Deviation (MAD)	254
Skewness	2.900690392
Sum	337262
Variance	624922.2186
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
180	49	9.5%
270	29	5.6%
100	27	5.3%
449	26	5.1%
130	26	5.1%
899	25	4.9%
549	22	4.3%
0	21	4.1%
349	20	3.9%
649	20	3.9%
Other values (70)	249	48.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	21	4.1%
30	6	1.2%
40	7	1.4%
50	1	0.2%
60	8	1.6%
70	3	0.6%
80	2	0.4%
100	27	5.3%
104	1	0.2%
130	26	5.1%

Value	Count	Frequency (%)
6999	1	0.2%
5299	1	0.2%
4350	1	0.2%
4160	1	0.2%
3899	1	0.2%
3499	1	0.2%
3399	2	0.4%
3199	2	0.4%
3110	1	0.2%
2999	1	0.2%

rating_amount
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	18
Distinct (%)	3.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.5206225681

Minimum	0
Maximum	4.9
Zeros	450
Zeros (%)	87.5%
Negative	0
Negative (%)	0.0%
Memory size	4.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	4.4
Maximum	4.9
Range	4.9
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.393497431
Coefficient of variation (CV)	2.676598204
Kurtosis	3.600363366
Mean	0.5206225681
Median Absolute Deviation (MAD)	0
Skewness	2.344308308
Sum	267.6
Variance	1.941835089
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
0	450	87.5%
4.4	8	1.6%
4.5	7	1.4%
4	7	1.4%
4.6	7	1.4%
4.2	6	1.2%
3.9	5	1.0%
4.3	5	1.0%
4.7	5	1.0%
3.7	3	0.6%
Other values (8)	11	2.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	450	87.5%
2.2	2	0.4%
3.1	1	0.2%
3.3	1	0.2%
3.5	1	0.2%
3.6	1	0.2%
3.7	3	0.6%
3.9	5	1.0%
4	7	1.4%
4.1	3	0.6%

Value	Count	Frequency (%)
4.9	1	0.2%
4.8	1	0.2%
4.7	5	1.0%
4.6	7	1.4%
4.5	7	1.4%
4.4	8	1.6%
4.3	5	1.0%
4.2	6	1.2%
4.1	3	0.6%
4	7	1.4%

rating_worth
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	19
Distinct (%)	3.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.5145914397

Minimum	0
Maximum	4.8
Zeros	450
Zeros (%)	87.5%
Negative	0
Negative (%)	0.0%
Memory size	4.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	4.3
Maximum	4.8
Range	4.8
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.379564417
Coefficient of variation (CV)	2.680892667
Kurtosis	3.650945506
Mean	0.5145914397
Median Absolute Deviation (MAD)	0
Skewness	2.353587991
Sum	264.5
Variance	1.903197981
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=19)

Value	Count	Frequency (%)
0	450	87.5%
4.4	10	1.9%
4.1	8	1.6%
4.3	8	1.6%
4.2	6	1.2%
3.9	5	1.0%
4.7	5	1.0%
3.8	4	0.8%
4.6	4	0.8%
4.8	3	0.6%
Other values (9)	11	2.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	450	87.5%
1.8	1	0.2%
2.2	1	0.2%
2.8	1	0.2%
3	1	0.2%
3.4	1	0.2%
3.6	2	0.4%
3.7	1	0.2%
3.8	4	0.8%
3.9	5	1.0%

Value	Count	Frequency (%)
4.8	3	0.6%
4.7	5	1.0%
4.6	4	0.8%
4.5	2	0.4%
4.4	10	1.9%
4.3	8	1.6%
4.2	6	1.2%
4.1	8	1.6%
4	1	0.2%
3.9	5	1.0%

rating_fun
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	18
Distinct (%)	3.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.5206225681

Minimum	0
Maximum	4.9
Zeros	450
Zeros (%)	87.5%
Negative	0
Negative (%)	0.0%
Memory size	4.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	4.4
Maximum	4.9
Range	4.9
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.393497431
Coefficient of variation (CV)	2.676598204
Kurtosis	3.600363366
Mean	0.5206225681
Median Absolute Deviation (MAD)	0
Skewness	2.344308308
Sum	267.6
Variance	1.941835089
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
0	450	87.5%
4.4	8	1.6%
4.5	7	1.4%
4	7	1.4%
4.6	7	1.4%
4.2	6	1.2%
3.9	5	1.0%
4.3	5	1.0%
4.7	5	1.0%
3.7	3	0.6%
Other values (8)	11	2.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	450	87.5%
2.2	2	0.4%
3.1	1	0.2%
3.3	1	0.2%
3.5	1	0.2%
3.6	1	0.2%
3.7	3	0.6%
3.9	5	1.0%
4	7	1.4%
4.1	3	0.6%

Value	Count	Frequency (%)
4.9	1	0.2%
4.8	1	0.2%
4.7	5	1.0%
4.6	7	1.4%
4.5	7	1.4%
4.4	8	1.6%
4.3	5	1.0%
4.2	6	1.2%
4.1	3	0.6%
4	7	1.4%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	Unnamed: 0	link	name	age	amount_bricks	product_number	price	rating_amount	rating_worth	rating_fun
0	0	https://www.lego.com/da-dk/product/empire-state-building-21046	Empire State Building	16	1767	210462104621046	899	0.0	0.0	0.0
1	1	https://www.lego.com/da-dk/product/statue-of-liberty-21042	Frihedsgudinden	16	1685	210422104221042	899	0.0	0.0	0.0
2	2	https://www.lego.com/da-dk/product/taj-mahal-21056	Taj Mahal	18	2022	210562105621056	899	0.0	0.0	0.0
3	3	https://www.lego.com/da-dk/product/trafalgar-square-21045	Trafalgar Square	12	1197	210452104521045	749	0.0	0.0	0.0
4	4	https://www.lego.com/da-dk/product/the-white-house-21054	Det Hvide Hus	18	1483	210542105421054	719	0.0	0.0	0.0
5	5	https://www.lego.com/da-dk/product/tokyo-21051	Tokyo	16	547	210512105121051	549	0.0	0.0	0.0
6	6	https://www.lego.com/da-dk/product/new-york-city-21028	New York City	12	598	210282102821028	449	0.0	0.0	0.0
7	7	https://www.lego.com/da-dk/product/paris-21044	Paris	12	649	210442104421044	449	0.0	0.0	0.0
8	8	https://www.lego.com/da-dk/product/london-21034	London	12	468	210342103421034	399	4.0	4.1	4.0
9	9	https://www.lego.com/da-dk/product/dubai-21052	Dubai	16	740	210522105221052	549	0.0	0.0	0.0

Last rows

	Unnamed: 0	link	name	age	amount_bricks	product_number	price
504	504	https://www.lego.com/da-dk/product/punk-pirate-beatbox-43103	Punk Pirate BeatBox	7	73	431034310343103	180
505	505	https://www.lego.com/da-dk/product/unicorn-dj-beatbox-43106	Unicorn DJ BeatBox	7	84	431064310643106	180
506	506	https://www.lego.com/da-dk/product/bandmates-43101	Bandmates	7	11	431014310143101	40
507	507	https://www.lego.com/da-dk/product/water-tape-854065	Vandbånd	6	23	854065854065854065	80
508	508	https://www.lego.com/da-dk/product/lego-xtra-sea-accessories-40341	LEGO® xtra havudstyr	6	24	403414034140341	40
509	509	https://www.lego.com/da-dk/product/botanical-accessories-40376	Plantetilbehør	6	32	403764037640376	40
510	510	https://www.lego.com/da-dk/product/sports-accessories-40375	Sportstilbehør	6	36	403754037540375	40
511	511	https://www.lego.com/da-dk/product/xtra-chinatown-40464	xtra Chinatown	8	35	404644046440464	40
512	512	https://www.lego.com/da-dk/product/xtra-food-40465	xtra Mad	6	36	404654046540465	40
513	513	https://www.lego.com/da-dk/product/food-accessories-40309	Madtilbehør	6	30	403094030940309	40

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Decimal Number

Other Punctuation

Dash Punctuation

Other Letter

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Latin Ext B

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Space Separator

Other Symbol

Dash Punctuation

Format

Other Letter

Initial Punctuation

Final Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Letterlike Symbols

Punctuation

Latin 1 Sup

Latin Ext B

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows